<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateShopOrdersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        //
        Schema::create('shop_orders', function (Blueprint $table) {
            $table->increments('oid');
            $table->string('ormb')->comment('金额');
            $table->string('user_id')->comment('下单人');
            $table->string('rec')->comment('收货人');
            $table->string('addr')->comment('收货地址');
            $table->string('phone')-> comment('联系电话');
            $table->smallInteger('status')-> comment('状态,0为未发货,1为以发货');
            $table->string('umsg')-> comment('卖家留言');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
        Schema::drop('shop_orders');
    }
}